SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025026 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025026 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (577347,90932,923903,1031001,920618,606079,443715,230488,860181,192952,474138,537020,122188,536796,204193,42500,975203,948391,320340,990735,734526,728898,451657,522170,147700,693863,614106,635444,1026072,769119,979930,409473,552582,802229,511857,769835,163310,764099,332384,716459,899291,540461,655522,865092,249758,388283,874258,779086,199745,567472,849915,788711,466190,357926,1024844,458786,428764,901388,472977,585421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000764s ]