SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001507s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36125 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36125 [ RunTime:0.003157s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348983,484899,383312,313160,946735,508518,879544,188115,368189,483795,440213,167127,20430,520046,313835,476307,651533,67300,162259,775005,904495,891632,1031994,130162,980656,822015,272795,950562,448258,759348,331125,348058,622262,526431,228492,968505,218980,304951,980876,507161,178981,1015090,861930,1040437,104707,655838,953723,279016,90946,815960,919426,499165,784366,942616,384546,250692,402429,933953,583613,850822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36125 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36125 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]