SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010322 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010322 [ RunTime:0.002647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (231897,124230,744731,372404,426572,756904,505716,451535,732358,696884,597311,782438,517302,645934,984421,312731,976601,328683,130718,244939,944070,744814,519192,995805,807870,643290,500163,333659,97626,75368,667488,834507,765808,130836,848091,542705,267003,419492,409636,402521,787346,322415,313374,609277,450492,650475,1027801,1013412,457357,403348,599196,545225,800147,1439,562459,1021750,540244,744859,49225,633287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010322 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010322 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]