SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460896 LIMIT 1 [ RunTime:0.001037s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460896 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975459,996770,100790,1023999,293538,1040079,743522,1030695,797327,472620,107843,336081,362947,374933,107376,609794,508093,967599,818307,448504,985072,261166,370506,168227,278894,303170,442710,665332,555178,804048,188355,784816,526567,962894,640129,1035376,490590,856600,691072,948551,365526,444083,387639,551121,899254,426574,829497,439287,588702,896821,360239,708800,991800,723607,165838,616592,1039789,566990,656096,898979) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.024996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002339s ]