SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516405 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516405 [ RunTime:0.004627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845210,667016,1032290,225774,1000321,93251,326429,205199,208086,736228,884618,551374,246456,1003936,705033,604921,338196,1023837,664815,842058,904431,22469,837751,230660,745278,996927,628598,127526,925180,75123,359865,1016352,25911,181798,87927,318240,290547,60300,949346,613514,885428,427134,242133,376226,474186,1002837,411213,655340,547092,593361,298771,143644,597792,201713,366249,652949,2147,123538,276722,502970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]