SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510411 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510411 [ RunTime:0.001504s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595463,629504,840734,912542,763722,973419,89313,22020,714800,877392,974505,1036836,174055,116272,443957,474859,974441,434460,961532,49802,187136,266872,487209,817618,980095,335200,236494,773430,987063,890415,1020702,271070,511337,743417,837781,711749,517241,760460,655257,290450,323837,697449,226171,46428,347929,278026,383040,2278,327064,180521,559245,783517,809299,707706,803963,727003,913039,164878,457985,1000193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001769s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004320s ]