SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105525 LIMIT 1 [ RunTime:0.001506s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105525 [ RunTime:0.002741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412023,409553,432071,801994,591797,566284,118618,1004056,109139,319638,685219,395375,729638,323873,25014,349528,942347,431219,425506,454412,293629,147647,695517,128467,586142,946504,476625,250953,419858,389143,128856,275416,257361,658946,974896,529108,1012835,209451,739648,111499,192011,467511,922083,473650,818847,391977,75762,921343,439127,877412,94219,705671,871177,563318,631854,979589,692608,139371,280695,787347) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010883s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105525 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001243s ]