SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419794 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419794 [ RunTime:0.001842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467408,96564,235385,1018153,777456,578781,963801,756293,635761,633538,747573,304143,805353,541855,985679,826098,18733,517382,31919,814039,547996,649295,867114,334679,884376,310911,481249,605890,569289,45911,560456,686634,849921,658019,904468,959495,111292,872571,599342,520740,67227,667317,64578,615937,125147,592647,196713,271077,783842,751580,242414,886827,808409,1006666,653781,336061,211394,134465,552284,371652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419794 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419794 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]