SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001668s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326045 LIMIT 1 [ RunTime:0.004490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326045 [ RunTime:0.002554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703042,580718,273277,121747,610274,396007,566787,847456,1007712,403608,439200,979478,678841,383708,878312,621202,598938,60295,41253,636397,288087,281694,246746,575705,901191,395450,822260,807456,753991,436711,605350,16931,465494,994431,720019,458841,672918,840812,167696,241576,849765,355346,441521,90349,89505,49232,545064,351339,516418,773543,644179,719018,1041479,156092,918496,599062,380812,629501,833620,683171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001082s ]