SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 624326 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 624326 [ RunTime:0.002894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566031,494706,950927,439819,433086,981331,737244,529159,1048541,602754,720117,757176,43507,779139,669388,504832,539443,925037,224660,21984,615908,181267,934522,49940,122140,286281,615477,886157,294137,219104,1034789,106317,95324,563898,840947,1048168,195980,228626,500004,977484,853302,246768,370032,377986,1040372,366187,925207,237086,412000,954133,993869,488486,762302,190906,591568,478749,255379,1031736,150636,841197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 624326 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 624326 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]