SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 974516 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 974516 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (709492,810676,935819,222185,584012,466412,277505,352975,23296,743402,1003496,592280,841955,644450,215709,620442,704015,464335,128275,571002,867938,96175,67176,599472,176850,211155,438964,80825,134105,372316,86446,127185,774686,532952,749100,812994,626790,424519,380451,92550,937908,847804,282600,13457,198395,405767,598720,552391,750656,878564,535645,641038,351139,872376,393363,235917,710816,470987,297993,209660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001656s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 974516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 974516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001657s ]