SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598711 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598711 [ RunTime:0.003692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423645,58295,1016439,156954,463211,634943,794515,342466,129218,272221,6338,657898,764817,163793,474090,956203,739942,28326,519159,98594,473086,32940,577700,995112,153954,286899,531233,521465,353241,671624,749552,266011,588438,787950,268178,748603,776349,576296,53984,874850,583517,851145,180105,685860,553173,92215,428510,515193,320215,225733,897483,1000660,978696,234310,143497,640653,1040881,118858,407450,942202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000987s ]