SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 120063 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 120063 [ RunTime:0.001512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (463277,438148,456054,4754,181161,284524,928396,782693,1036013,70076,968721,525233,57848,271333,30270,651191,786187,413145,127898,264217,251482,834417,393306,355746,308143,617176,356172,513909,366838,213529,905037,421191,490850,359571,441948,324646,947200,567713,824609,102282,904880,898012,115497,568604,77217,651004,959688,711073,273631,122649,651364,807285,498222,619613,844594,592622,760647,949367,539763,308325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 120063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 120063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]