SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402321 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402321 [ RunTime:0.002977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004041,1017720,600087,539542,801632,755405,416889,321770,559015,405858,679000,232214,806107,49673,669658,580978,936140,498585,941643,441976,546393,124147,172658,803652,304241,24337,756705,626809,780015,204905,760661,520481,707996,58270,465722,911570,662514,775864,865951,68214,143559,282176,570240,210276,449588,533832,507573,162173,956067,866591,607165,142697,759818,599993,389150,93585,476410,250062,852208,329715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402321 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402321 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000850s ]