SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 307791 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 307791 [ RunTime:0.003650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034504,959317,384547,1015568,737167,628125,10535,845567,629353,983629,551338,625078,736752,662000,803134,749,714737,747518,550900,241771,149807,156870,898985,238223,359625,959450,500340,436531,160977,1017968,920938,289424,278357,718879,378902,373417,456407,463168,452917,869061,871428,310696,325397,1017073,864712,760976,994433,500086,546522,437553,845580,724209,595806,658169,2564,152648,792843,255909,1012862,446674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001680s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 307791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 307791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]