SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456621 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456621 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122523,708398,167193,439483,811148,671776,347311,536896,1028834,706957,664668,77818,404983,323498,1039395,656940,533593,800501,984299,728450,244725,819757,586207,824409,766204,459231,86948,606027,994956,11384,11035,587570,479659,618284,456844,915289,62950,879159,498690,552118,387299,461947,61824,1004456,504460,935151,985571,97995,765071,281685,574270,554945,817929,173863,881091,640991,513741,205968,27283,742770) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]