SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354449 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354449 [ RunTime:0.002050s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (724112,542140,571890,1046649,678618,635072,524599,40962,150523,137968,567368,39813,984431,71214,54808,381007,645391,603480,268077,310216,577354,98724,161445,780026,357200,65063,418784,87033,1039858,83199,595833,599252,160948,661254,244595,900481,8034,895059,935935,287678,551228,96375,607495,57481,195625,550250,771137,449654,943855,229078,382940,304156,92934,366067,855534,469200,633001,544715,651017,176302) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000905s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354449 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354449 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000383s ]