SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014862 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014862 [ RunTime:0.003021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (837181,866022,1002773,400627,586135,1045072,413346,374492,796729,835534,475847,367036,637968,184011,33006,277014,897858,1029688,587596,173837,348111,143534,253767,284200,454315,701918,200522,302061,380292,977392,429814,567175,773284,585839,283944,553334,794745,1002150,530293,58337,689118,811970,281803,561781,931991,638081,1017031,450026,846229,556792,70497,533692,419827,654963,531790,529179,229884,197603,52885,770470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014862 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014862 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]