SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54321 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54321 [ RunTime:0.001516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113495,841871,688529,332277,336152,915297,709106,771710,109764,810638,888893,34478,222680,678845,824775,889685,972144,88844,89552,833239,40408,122656,480613,657165,1011724,255728,117786,843877,59323,626444,789050,272993,574716,649625,409712,417031,627957,732008,826975,287404,442551,51782,95958,73842,986646,649733,523326,916333,183332,305168,827444,727382,720171,5608,805657,922851,652077,139667,590074,487334) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54321 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54321 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]