SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520321 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520321 [ RunTime:0.001538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190937,457217,712273,510367,735762,1020307,1030656,296402,928235,453676,1021551,688974,78607,341238,547030,344250,81071,375065,613590,1025998,736990,350400,397543,256481,854836,263411,125366,1027732,471156,221428,726926,979337,532029,374456,527333,807496,347414,71129,949400,426958,207235,258174,191556,547376,465609,417416,554738,631310,129745,306160,219338,479950,584197,10584,853667,791692,168194,988783,957900,595693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520321 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520321 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]