SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022289 LIMIT 1 [ RunTime:0.000517s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022289 [ RunTime:0.002131s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788705,542092,197800,800844,190331,511607,53620,914532,471190,187311,822695,408509,919975,291891,526998,601787,309849,214063,957606,446984,774963,303385,218594,780058,1034567,415157,208692,1001091,375368,946504,591554,743310,406295,514280,609815,948229,204455,678915,584558,799271,172093,156491,235670,108313,21316,129170,813774,909475,246155,688548,254907,646379,1045471,846563,576463,497112,966581,60604,818641,225781) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022289 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022289 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]