SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001438s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443314 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443314 [ RunTime:0.002967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201387,587821,800711,798419,792774,765580,647533,928191,580339,639448,3858,771994,1003048,964758,1047974,514045,816353,926867,368098,903334,297295,841776,532961,96159,1025497,830468,907074,30914,641637,1030194,126095,336712,619513,1040635,612695,58065,493867,874394,491763,1009251,243186,350408,513144,164562,735309,78739,905032,377259,455353,743047,129607,117397,559869,699982,346851,713777,988232,872095,1019994,528642) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]