SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547820 LIMIT 1 [ RunTime:0.000510s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547820 [ RunTime:0.003276s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619825,59744,435916,628142,148925,572199,6153,380502,838423,910002,978427,792480,4381,698952,404280,922962,462854,104886,702143,240049,863021,541054,25828,314582,634318,655182,603406,747140,588598,241358,387430,238174,22373,797637,806349,556173,119474,194069,508415,805437,339939,771055,372895,152911,785935,743555,247240,462767,187034,180063,534368,496489,253602,423916,147767,132322,11214,141044,711348,895335) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]