SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507396 LIMIT 1 [ RunTime:0.001373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507396 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (889090,929001,347253,739259,837829,803301,793046,796106,889975,913756,842554,624417,200311,655563,300429,514012,108832,294503,807638,831150,827886,896350,868282,1014498,429175,325181,899349,31187,487754,995318,144007,195056,527800,414235,655701,270364,972291,654161,873596,402916,91323,667942,824700,611825,219470,395679,698770,700586,372473,405336,687569,33258,463617,927433,165920,292178,126210,688639,254313,845866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000393s ]