SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285612 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285612 [ RunTime:0.001787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119007,795802,34773,215671,422623,963560,597425,402931,975555,884218,648940,742800,364312,318165,247712,939541,541548,554977,908206,695967,274403,561353,469117,122551,444950,732604,557722,603003,782841,195461,740736,911701,657071,242674,512706,930317,209619,614342,655742,313612,773063,657831,516599,302019,696846,79242,624964,59623,430717,165742,618503,578114,383096,31162,836940,110152,472209,322745,396072,258537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]