SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450221 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450221 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (11039,359543,242963,986123,395109,411931,1006733,977423,460562,659310,837143,34108,439808,1008114,35391,255021,409067,96512,523532,413285,538165,320875,828067,986470,588206,1003993,265810,206008,167556,266360,841728,288451,1033171,412407,426132,918624,630594,1036879,595863,483750,690474,695210,397906,534904,793556,555644,231203,126783,364984,365537,641955,217757,533864,216599,672650,226701,312246,501527,182044,794784) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]