SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314437 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314437 [ RunTime:0.002255s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014581,679893,502185,897341,424130,187117,767524,488762,626721,443243,351959,941959,110426,628538,264074,430194,166283,490137,232745,250628,798355,153072,754691,460090,880997,239997,43329,714363,407166,718052,2944,566096,425406,906524,112980,97373,671247,418938,385991,850164,820314,365532,753216,338144,398507,758526,398131,642743,967108,263816,929685,33138,8031,270298,154434,587843,592165,881176,187981,1006901) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314437 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314437 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]