SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 641026 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 641026 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515098,106554,226649,766725,156767,664098,332666,634118,102563,369270,491948,1002606,716663,641388,59821,831838,96887,198194,1045889,862350,480256,138707,1015450,257139,647176,813052,1021732,848567,272212,582528,29716,861733,268884,683525,332006,567020,891819,125582,478845,3677,277839,135685,435753,344427,776512,774022,5428,803174,530158,939825,920096,794185,386623,10575,1002799,987487,372346,939284,733573,109802) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 641026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 641026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]