SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 16401 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 16401 [ RunTime:0.002339s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541062,201548,363408,384827,229745,861793,705125,316757,385097,134177,164005,122107,427881,241857,513397,907792,808844,222328,400242,921210,980491,54625,1019069,478972,498156,678221,339737,200012,107593,330117,818746,854259,261792,1010179,1024597,778621,674817,272445,919198,4572,776302,81304,268683,842002,688989,302966,289470,56162,149491,138605,433820,326862,949079,401064,891396,932097,928444,412988,297146,148155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 16401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 16401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]