SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567815 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567815 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317080,93625,263123,362618,101019,124321,751153,487093,254715,571883,233539,776603,927471,738409,69490,62980,524910,306628,492325,239899,777074,971591,188871,627738,131775,523172,70476,632076,271957,784789,933445,448051,646615,903425,646593,632398,1022786,661837,516706,948604,227444,449927,785594,461741,281010,243266,999003,1019906,914467,455854,411403,113785,612068,197430,839517,927699,359597,305903,457136,513911) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]