SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200465 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200465 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689646,370776,622271,802584,948510,898086,547089,422125,141370,837617,17846,836822,521838,153205,915866,400613,206321,81852,455118,845516,255097,86657,914026,954369,764453,636866,265160,307279,422094,464131,67602,202976,423163,114517,255766,832553,597431,209765,428502,536393,854834,164094,1008004,232012,15936,510158,780118,277194,592839,405099,475792,36825,301922,858408,618699,687670,258847,693842,892525,328213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200465 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200465 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]