SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 740093 LIMIT 1 [ RunTime:0.003833s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 740093 [ RunTime:0.002809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122381,386991,622641,962515,4703,479527,130838,768683,593190,540114,1015594,952798,690123,676338,502492,843450,489539,311666,24989,903046,991181,721483,635727,198987,1010025,78568,1022982,168035,558987,56071,906936,446197,201445,280995,119391,722590,670351,621436,517204,47795,160807,710607,673171,387905,977950,360007,929554,692784,620736,832566,480021,689437,951243,454567,149553,104103,590006,314229,898259,683275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004872s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 740093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 740093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003836s ]