SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445521 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445521 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467726,151523,455808,677935,502024,959819,352118,25712,725096,136455,813198,182692,103912,866200,660383,1018658,682097,54364,875943,838517,971873,428627,431241,863033,185646,720298,915639,479275,219866,643350,439404,322276,736280,222226,825216,107086,11743,679190,266526,311383,776971,265723,557075,809231,634495,301053,152973,451624,958308,363320,171004,764669,163675,840757,814170,794359,788775,811560,719534,16387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]