SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424610 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424610 [ RunTime:0.001972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58211,67716,270677,148701,81437,709663,932414,687621,756798,603981,950059,384220,184105,658338,345741,954748,805166,1013459,487724,854124,139411,1022914,733010,1008641,676439,993164,585503,670280,958673,100429,508173,518275,904574,551228,761630,29344,845434,437699,760435,351080,747891,195382,475395,950694,355552,355221,993557,781507,918366,768969,856551,340344,118882,41049,90036,372118,709048,27457,1032476,697826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]