SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528499 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528499 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513751,168604,581437,874052,1026609,809293,44102,817875,291195,735624,179481,129576,5468,165973,673466,653928,331322,150995,743550,893388,762890,268826,193294,685422,841205,628772,400667,813193,325548,600722,762708,482801,933875,372649,835199,419338,34774,319272,191927,688971,521360,866585,889873,679091,318130,44592,885929,37876,530023,61764,337031,638803,290839,229764,140948,515085,794724,545018,230185,188591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]