SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 677396 LIMIT 1 [ RunTime:0.000814s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 677396 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512498,111537,609313,38838,646261,836862,940614,961843,164745,435450,489460,1038108,3641,984067,271464,190686,863717,910477,681238,168276,164936,68885,1031073,953680,762292,686332,719056,552128,709047,893657,410433,422402,666436,717126,393132,102210,993749,437872,994734,914794,590683,436983,302440,382957,839194,735838,570488,1042376,569191,575171,240216,351674,603777,933954,1006999,287656,925644,371229,86486,968778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 677396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 677396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.007293s ]