SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317528 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317528 [ RunTime:0.003214s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (389614,611916,187318,541745,115657,892987,711476,104939,28661,208785,51866,466801,621382,759109,536355,154563,1016877,75368,1004507,528862,608849,257645,812315,219730,535203,329930,91354,447853,663096,963300,554287,966152,826456,210007,188806,476474,250101,347742,253528,468387,78816,197783,823914,418839,713431,984449,198813,741438,623015,674950,241692,761152,880123,511823,485644,268456,276490,316247,1003074,615608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]