SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 696041 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 696041 [ RunTime:0.001880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404413,364474,893604,213292,613848,354899,596519,335631,776036,141793,617544,649558,383121,569765,681576,19160,22102,281449,443524,608448,326189,822157,856642,640462,27648,275423,512181,571434,199973,892648,510799,266698,2029,845554,648709,212658,90245,512827,315323,934145,1022212,24233,455525,535467,985712,687389,105363,386955,87722,97286,395380,873788,445246,122474,22730,162034,386599,247763,726772,85580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 696041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 696041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]