SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809708 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809708 [ RunTime:0.002581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404643,339349,917564,315361,992064,989191,180324,973882,861555,471346,58464,194992,1004163,63765,703239,924503,218451,593117,691962,597207,142187,1006236,525424,212075,422153,581378,107216,669898,986831,32611,666950,730976,674323,604986,167859,332660,1026974,687887,368251,63390,413432,454740,612794,417388,383,982824,617578,497686,382038,673318,173061,270421,384843,1028165,769456,716518,642345,98169,664750,961107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]