SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41120 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41120 [ RunTime:0.003386s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (601905,139755,448690,1019014,222260,567134,52021,174692,871787,1047123,536115,739863,82247,721611,168054,970432,562647,478746,152722,960925,88584,968995,425168,791714,554704,885289,374228,477554,59057,222783,542178,228816,290839,517044,244391,622044,63072,279066,139091,348915,87426,817245,775720,906146,847673,220138,639065,103664,880220,557057,594167,242512,984720,21029,865360,164415,590040,250237,794857,773249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]