SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 160513 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 160513 [ RunTime:0.002227s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (834604,337006,506995,198974,226557,103588,568349,553597,743229,1004899,265697,855819,271687,784517,797358,723711,518662,758862,35914,566131,13111,60175,606796,805065,282168,783681,447242,584122,380190,277922,263020,485114,1033156,426835,82537,1044292,111142,674227,6594,700458,27837,553771,1002457,916886,412578,11800,767434,580890,56999,891064,709558,583282,496034,293503,1033336,387176,304829,546469,273524,464056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 160513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 160513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000879s ]