SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001541s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 841968 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 841968 [ RunTime:0.005643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793615,342840,770986,1039384,633632,329984,186008,89226,770825,559071,610048,719834,231224,1043129,435923,266184,827308,422826,665846,159878,679575,648572,908725,178797,442423,627865,910726,141244,932744,494417,217261,1025155,151974,714914,356393,397413,692278,140151,795903,632727,251535,794537,576363,774922,289944,1043739,931260,93472,551858,717133,191460,748602,348239,783060,946781,938055,247859,952727,243568,908212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003601s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 841968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 841968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]