SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 264493 LIMIT 1 [ RunTime:0.001379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 264493 [ RunTime:0.002836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (770803,748988,302849,943397,446060,854567,726463,80336,981815,119683,605976,3646,503782,333978,1017950,381074,258236,484936,57030,23805,231109,696168,212891,13291,23605,985632,850749,189985,235844,749393,941410,611310,487664,567197,638060,633406,110581,44128,72840,330442,669687,700134,186912,795443,203678,426151,532094,353316,900810,881872,968931,769045,307620,285524,868952,408738,136637,914798,267473,861506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.037332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 264493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000602s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 264493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002440s ]