SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492585 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492585 [ RunTime:0.003159s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102723,385460,383063,331357,733569,175329,978524,165197,67340,505013,471006,901098,369521,496711,506342,614445,781373,716478,113223,737981,856676,756707,527942,975941,295923,51654,563296,396214,515532,423460,427728,638404,1007427,246795,623115,650552,226725,944328,45442,453156,968813,58898,248788,376106,713136,119014,60354,475693,818649,194781,571828,542652,600294,256300,336092,910897,580313,274934,900910,674912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492585 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492585 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]