SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527683 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527683 [ RunTime:0.007684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316127,310743,277160,386284,921281,793576,956027,769954,250048,1025410,852917,616559,756069,1012321,158806,779298,825202,925745,800445,248519,352560,197786,916409,266246,154246,464209,238838,576594,458260,291568,901075,274635,677094,441505,233051,112402,434198,390617,678384,617348,821363,353901,41555,863116,45027,60002,484923,287531,760429,1039585,786330,877086,1028660,961744,345562,1020988,297565,812364,586997,67220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]