SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 683218 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 683218 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (345085,430509,465001,262474,747900,523538,713480,351452,791285,665818,827150,697392,611020,538642,958018,623174,379335,705574,159145,905790,733020,828459,874430,984805,639547,995443,416435,1034633,552397,162935,983439,152135,509572,283963,612495,916486,322890,23177,936912,686579,469444,80936,74079,116576,832605,1020203,354099,212703,994813,19779,677519,521327,228399,1012686,66132,791158,190347,807647,744781,66850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 683218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 683218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]