SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 325411 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 325411 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (720681,904908,709346,816577,450907,718294,170178,686436,184495,1018540,341133,233220,1001979,942272,656244,158787,795737,971924,919173,905540,557883,581299,799804,826186,320531,273350,118675,293128,381669,269439,251586,793786,443300,583399,816751,324977,927082,161983,899767,1021813,238104,866540,216771,20035,813728,174926,334434,29289,148130,702963,574149,32622,143176,920946,432400,461238,1014802,811051,265501,335476) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 325411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 325411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002482s ]