SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001616s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 353319 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 353319 [ RunTime:0.002022s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009709,808983,521045,237764,405002,812389,240709,481881,391502,835314,91700,57060,408911,446463,1041685,109303,373073,874965,873256,624597,509381,522641,194107,303664,51145,880351,173624,779818,99677,396938,120360,1031073,773485,639400,57885,1012181,960008,731425,768372,576958,424271,1032680,135351,1025258,726942,985657,765648,501019,753904,292811,31602,680642,985580,628611,400002,132511,295966,751979,324289,667229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 353319 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 353319 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]