SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 262881 LIMIT 1 [ RunTime:0.003170s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 262881 [ RunTime:0.005674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285682,416845,462807,793808,981300,877180,701306,472758,428781,1010740,863200,66497,878681,661936,655332,54806,30507,777678,607772,786729,380007,155045,816661,234316,708353,967852,305089,119484,427822,562482,583647,23620,240674,143513,663982,632793,273929,374696,60251,247660,197766,537345,1035191,826117,1004777,873055,1048892,687522,503652,1017954,180588,714243,70670,466701,160791,996834,290900,360403,527652,395548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 262881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 262881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001646s ]