SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316994 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316994 [ RunTime:0.003020s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502266,65221,121735,459949,209233,813191,231869,772774,2121,1046648,981000,846072,778582,431072,122300,671534,791451,7615,229831,76063,744658,943472,593659,760654,114660,124036,797671,991507,898792,630804,681360,245778,788531,716717,738294,826480,434168,189860,700878,118316,607580,455839,908041,884683,851788,20688,729467,637979,396810,146040,196661,520173,593081,859,984415,731466,866738,775050,661864,62643) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316994 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316994 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]