SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001430s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102328 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102328 [ RunTime:0.003061s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (826602,22954,324297,415739,980569,304150,71284,456076,915631,97541,85748,373461,264965,705625,871959,33683,475735,883554,732494,393083,89750,80138,604725,428008,184916,6013,252775,589580,515468,591074,898130,688073,46684,117785,1025405,706562,189023,631165,771872,253126,150587,922150,57440,295632,457273,849816,795460,946910,563491,892644,11602,971439,139771,179224,202620,236940,120540,182044,896388,490394) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000723s ]