SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003997s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501042 LIMIT 1 [ RunTime:0.001885s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501042 [ RunTime:0.002971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185680,876033,592269,299979,904161,209462,295386,475621,408383,1012265,569351,729336,385291,832392,618867,565849,403134,535212,900177,741082,790725,646423,305912,1013022,546198,170396,175600,798050,738797,750640,890460,870005,646339,979280,750548,784431,704865,41534,380765,371643,95903,470222,34580,675993,839522,601323,997672,815732,339101,933355,967821,1012680,475546,164009,677020,764497,891351,340371,989078,455870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006729s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501042 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501042 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000809s ]