SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681471 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681471 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (713057,126293,568404,1015241,719594,133402,1001284,726986,214983,23366,98553,881064,245383,637923,827659,155841,183155,89625,149885,5354,323512,241201,433250,138102,822890,715581,909611,175692,431186,984705,565976,421992,992641,664824,299495,260153,59475,500014,48943,80415,605151,766841,623612,344184,460210,78815,738243,638500,1010293,355563,800306,1002209,859082,1048021,238996,774237,937600,837876,48119,826550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]