SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391064 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391064 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128251,1018471,520677,303766,124748,949146,604599,371661,276904,268452,334191,358795,574004,420969,826472,841974,69118,37157,429209,791881,718479,971746,1039986,489565,615261,745233,558819,202618,179421,602786,20330,235090,158514,980940,982220,82070,239884,797169,764856,98268,933709,923214,37892,612259,729646,847988,280072,552934,1030186,110957,865488,71675,979713,368772,12544,184887,717207,1028155,742546,127171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002862s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]