SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472593 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472593 [ RunTime:0.001867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (177388,913672,775042,4860,853626,179098,453710,644753,401019,183328,29453,349450,377795,70521,597963,63616,656362,768827,441019,456636,509256,350819,314475,825481,514216,424280,1019233,73429,213766,951181,51048,442249,558802,37965,706912,923595,427099,206866,503182,908601,228986,17212,551387,652567,827733,694892,922510,399659,800913,955964,329672,130920,415914,875249,782587,910480,785789,348692,457423,885700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]