SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291023 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291023 [ RunTime:0.002215s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140112,170251,562058,806432,542077,1029874,394160,744745,851859,702171,291859,657821,564409,584712,915675,303490,336997,689183,902443,776545,669542,49457,608737,620132,915145,3059,142049,160926,857168,971837,272135,427243,116819,678226,112850,169854,195965,415706,973885,556489,487305,160112,77908,425760,819792,765889,286961,421455,306588,510097,739563,752971,961383,632370,335265,853429,227108,226179,223532,31950) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001710s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]