SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002031s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557263 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557263 [ RunTime:0.002276s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333397,200679,622022,573362,638402,463795,200702,567579,715788,978022,541880,984053,88201,502538,836926,1025211,455885,93451,841959,553470,792320,9018,195361,796302,708482,756443,374769,649325,133759,885283,920314,658784,1016202,106900,483051,318952,347735,496245,1000686,1008540,186308,868608,141645,892198,440214,746008,198244,888709,461044,714765,892476,406604,323409,940103,183393,531458,740439,596020,169383,728981) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000665s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]