SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039648 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039648 [ RunTime:0.001704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (66231,754903,657158,376010,288066,583455,150199,662595,826546,627606,250013,35026,43282,533322,704210,365005,696453,290294,857037,355654,121317,873865,925092,801673,928658,305655,555315,39758,833385,16719,248079,55186,30539,236100,215822,502769,759542,882777,797909,209139,992627,498029,6749,814592,561633,217574,43867,448088,573132,22904,619200,422066,951831,504548,858920,122744,352891,238525,713061,544570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]