SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200411 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200411 [ RunTime:0.002220s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (366783,145272,977086,613435,844807,669491,72147,839752,636286,432472,720077,395483,572196,451602,767076,857883,296454,48217,495450,382766,39973,172011,616737,826063,957635,125231,32157,262769,615701,813009,318933,722883,137576,544671,546849,384398,311696,501062,430566,558222,923353,584651,211646,515918,671960,292427,319290,129193,416702,190751,848801,364818,227691,388456,556096,557248,689693,744307,560022,962129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000695s ]