SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023260 LIMIT 1 [ RunTime:0.001141s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023260 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41607,407911,699161,510018,254770,52374,26932,379160,738478,728289,205904,597867,422770,972765,518734,652322,340115,413031,185150,581607,324202,85593,111139,379306,835616,920164,621975,816127,498539,419490,989021,160309,331698,907218,350061,135288,576805,1012366,6995,583756,443756,362228,447108,671986,157328,884792,590311,345101,924208,341353,185822,509208,487265,305400,244954,668592,595970,333136,746373,912310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.035857s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023260 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000643s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023260 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001816s ]