SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001506s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547499 LIMIT 1 [ RunTime:0.000632s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547499 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (959118,322934,787409,452493,479168,488689,412823,399244,677803,425119,854945,726517,657294,564112,404837,538797,65012,653255,883201,835521,293262,492044,584071,586262,549573,843695,1007133,12769,42344,758580,910114,196546,737740,798086,122223,392617,462992,803114,267044,687690,861537,1032432,653340,218534,746020,1007671,539186,958376,853779,497345,530131,322828,1022792,933609,60547,502776,838904,624772,424332,829233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]