SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101064 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101064 [ RunTime:0.003690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975444,363388,1007836,4595,713205,16532,401618,451664,235257,716430,705890,496962,435335,715181,358227,901623,638285,427996,368828,923193,444134,172951,670570,488963,914196,371224,19548,914112,342718,706661,33931,337151,857705,151618,541440,527530,70794,586841,727116,121902,379155,925775,974516,629525,1027461,416319,547039,729333,1001572,23995,854187,861549,626046,946629,756761,213982,1020442,938256,39640,745623) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]