SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3201 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3201 [ RunTime:0.002328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207980,856250,880844,234743,373183,641897,737177,282442,711311,175846,762920,771329,496846,511476,178546,969035,551469,10757,1015565,986629,291997,451042,13008,908117,129231,832452,877684,761684,858381,187877,838607,732207,711668,720942,874668,634110,1036217,896874,849913,645998,108930,171396,282923,1012196,333681,303534,474803,954189,536618,825137,536335,112167,938288,77950,665341,147666,268878,552825,611015,700862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001824s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000711s ]