SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043880 LIMIT 1 [ RunTime:0.000550s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043880 [ RunTime:0.002357s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000887,1013927,789926,577282,791677,238778,128675,194539,548856,929051,310755,48820,829188,983065,929339,374954,959525,289992,855328,162528,61995,1019613,897638,195362,786310,125733,651227,316035,716055,549518,982264,784489,493505,997597,303417,514992,304741,436411,78986,103475,385602,473061,546696,936319,359490,342826,990765,859406,16767,550048,904829,202037,599471,133414,501167,452979,263796,524593,368104,460501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001286s ]