SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 808410 LIMIT 1 [ RunTime:0.000553s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 808410 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293036,658295,591252,53493,207016,242826,537806,984700,845120,146453,366555,1011691,535648,358291,276400,364160,30060,93391,160311,515858,458072,907955,338709,935905,324683,157834,1046772,761300,277620,943468,194208,25874,812819,660101,990779,407066,826545,969485,545174,347446,566866,494818,398579,401856,562028,687918,301717,290528,720065,568370,470240,216393,527327,711125,100968,103130,187313,979932,149506,964749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 808410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 808410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]