SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028768 LIMIT 1 [ RunTime:0.001567s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028768 [ RunTime:0.003802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469384,519227,794284,659972,392174,846424,421308,311346,362260,972459,170027,1043912,29266,185609,888206,40375,568432,596704,195416,144596,257714,34167,595205,227162,1028854,703833,176147,1034671,1037003,489768,302579,739280,970248,722324,481498,546467,634056,1035569,590244,1011887,236446,449208,497313,878718,11040,24891,340664,608975,655448,347085,417390,13487,1021200,487473,487973,327520,77362,949323,410936,389594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028768 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028768 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]