SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010726 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010726 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493648,944525,573889,315255,664858,146174,249162,520493,768829,323017,549481,337363,93534,122419,267433,527493,965532,903367,1041221,50086,139628,25662,161133,603230,298603,316941,797251,209305,860137,153036,267096,422032,540922,374343,312071,965003,535217,452218,363668,688907,354373,575526,44733,562772,772973,904604,570900,460173,981146,633709,344920,516480,890546,2994,151400,5027,259805,1026869,237574,447893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010726 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010726 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]