SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267941 LIMIT 1 [ RunTime:0.001460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267941 [ RunTime:0.002104s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207851,1008526,967998,761330,42411,24551,101636,168194,627122,847098,539335,317269,533015,656052,462013,516018,117293,890087,220329,412848,49228,425647,752632,823156,646090,176,340542,558899,411119,635103,572343,218387,243518,160148,964778,157171,986586,997635,222812,509993,23456,230906,285207,1548,1010406,1013079,392591,16222,767859,265825,617347,109091,839736,885587,347466,875961,391420,57070,528281,166565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002753s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000972s ]