SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001091 LIMIT 1 [ RunTime:0.000508s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001091 [ RunTime:0.002287s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328101,663135,171422,145541,562507,670583,395258,134824,575223,60039,1044300,955263,197978,987198,781755,440060,605523,822217,217885,612834,634735,629794,161421,727067,327527,303323,681682,915951,212193,983046,238734,981766,1006397,201992,1009253,441052,942153,292883,295067,189517,812331,488052,560042,593372,402960,349370,509505,676670,140161,55764,1033400,880170,549364,361803,109041,825341,391473,109581,50420,844120) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]