SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 579039 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 579039 [ RunTime:0.003409s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819200,110994,503573,57961,891397,884184,386161,849714,813956,81110,360759,636983,432202,926894,61470,63697,753511,527378,117253,83119,152744,317311,137841,33176,456803,320161,599051,194372,583175,579915,566175,1026097,375523,197120,531123,22274,56111,591391,1040593,799575,961325,144141,511797,47338,640444,120109,796961,231434,327151,134210,578688,602197,630904,126767,972699,613196,279600,1040508,88848,869607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 579039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 579039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]