SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420560 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420560 [ RunTime:0.002178s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029801,533501,107361,348501,485903,806675,13476,152241,441154,114108,48464,716740,328191,624413,378531,586394,118234,761884,238174,263097,635757,750960,988648,639917,305848,999363,569183,99298,733749,163238,691012,354724,875396,711191,705180,582592,206448,330266,881780,880632,479397,474840,316713,949093,418869,373217,886175,837082,454509,2022,404716,690510,418803,292143,223409,567127,272737,753347,566823,832337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]