SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001449s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802054 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802054 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427376,210641,1031364,667079,162078,102930,907760,685420,907112,768334,223144,68718,1023240,1044861,261167,346721,754725,514395,636494,629286,401788,88011,263912,896700,609218,294480,119425,857080,749359,986923,55120,250913,298755,209654,337640,863515,978604,795903,586547,544012,27648,230092,687277,559966,1001015,268950,1105,229128,1020988,942320,85288,64492,216557,284696,340525,46778,25918,614155,238639,205149) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]