SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522511 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522511 [ RunTime:0.002075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (233281,243480,431983,212551,801532,1025031,901509,495993,975613,239756,413610,299273,492996,428419,284937,398141,936141,75134,583553,457540,1010616,909158,586110,800447,1011433,867895,277685,794220,635939,861835,617797,411378,518452,200092,176314,21873,53586,1000216,153238,1037320,139651,760313,609228,723269,27610,424336,704024,312639,333442,580009,16891,540647,532683,874157,403447,861749,840393,863960,909036,680408) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]