SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 824002 LIMIT 1 [ RunTime:0.000459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 824002 [ RunTime:0.004149s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840518,142770,1020539,348414,425372,285229,813693,364357,276924,376632,583678,392182,168520,782871,904731,969455,500291,630594,663276,146869,20744,360547,349414,751793,296073,1003294,35502,160431,986213,118018,10067,33491,633579,900730,285168,733518,139220,371053,1034593,289363,720555,59174,564803,635298,162782,23113,599947,962674,735148,615524,548443,178812,452385,376500,784825,188394,376025,420278,732628,317161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 824002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 824002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001133s ]