SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 821106 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 821106 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503169,1000447,1042412,598246,15583,702841,500754,638914,881462,862998,453528,380931,901244,105515,353987,472956,462989,606700,731059,313229,576888,418729,49609,230818,851491,389330,141340,848659,349949,638475,915125,639705,697854,387414,773347,55487,1014146,300988,765935,393096,888222,561023,616652,482828,851055,1004154,434609,243452,265262,884513,60583,547599,775905,326518,123304,964662,641334,336916,848577,343817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 821106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 821106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]