SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196811 LIMIT 1 [ RunTime:0.000709s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196811 [ RunTime:0.002327s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408325,868963,473254,674469,223861,409775,439330,729522,444886,168991,280472,9169,818329,515280,1001044,158079,13012,341315,65542,801621,813545,82537,230672,366756,88178,257235,502354,158231,160701,677340,998424,993723,91213,132389,459503,639337,518828,693234,972444,302039,318562,815602,11999,655155,754540,618816,81622,109522,993264,356061,949487,272866,984861,129625,514377,305479,367575,262716,180343,780649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]