SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447628 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447628 [ RunTime:0.002450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415567,1001091,609773,790903,159587,901637,162763,668144,927256,586344,179930,854661,131724,1001800,401843,82208,978584,182023,730652,276310,969897,271590,57724,13107,927495,463035,229180,873348,469752,224880,326108,441536,287682,97761,907281,656,715208,235648,830385,960186,1008959,210602,779085,74524,63786,881289,428631,527874,895825,502401,652172,763550,223351,76366,811012,585542,578279,136940,795283,835890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]