SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038044 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038044 [ RunTime:0.002547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529954,106746,222029,701734,152923,583617,285905,386809,582968,800295,575664,133893,655577,346357,851913,883032,717937,770292,236056,560057,479016,93693,271713,676909,721097,163829,982195,272484,988025,87459,564792,1004721,1002863,42324,393341,739884,415351,1028047,1007105,331172,57290,86798,1015616,27588,833481,625074,802904,876135,594490,449283,767129,961290,45540,104343,791442,698925,723330,994582,1021824,214893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038044 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038044 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]