SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040311 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040311 [ RunTime:0.002928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362566,596620,968631,106788,1005745,157579,945473,329246,407705,872657,415140,27296,1040257,512583,781775,775498,920387,271914,872067,794740,965605,234945,922729,468670,915839,625095,469696,721036,65615,484741,284020,309599,805088,637531,530001,42458,510051,584598,766550,207877,644646,703463,313583,361080,374463,209682,132666,551860,924249,803061,466986,855249,258625,974911,1021922,948193,566479,1024657,183000,612172) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000699s ]