SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5320 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5320 [ RunTime:0.004932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (341465,733568,308739,788859,339111,699875,317144,910196,672503,383846,170937,150268,450338,936477,528935,1023063,158024,887031,200415,633628,654330,799669,630885,934930,806970,608734,514935,412328,773695,706477,242711,458744,604669,271172,438746,479290,608119,323229,1038437,1020280,999088,269140,184882,581112,379615,805605,342118,820077,950155,567088,1006694,871015,754095,563809,321049,217036,57941,841584,685648,113784) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001435s ]